package com.gdit.zax.entitys;

import java.sql.Timestamp;

import com.gdit.zax.utils.TextUtil;

/**
 * 按播放次数排序的课程信息
 * @author lenovo



select *  from t_course as c
inner join t_coursetype as ct on c.type=ct.Id
inner join t_user as u on c.AnthorId=u.Id
inner join (
select CourseId,count(CourseId)  as scount from t_seerecord  where DATEDIFF(now(),AddTime) < 30  group by CourseId order by scount desc limit 0,5
) as res on c.Id = res.CourseId



 */
public class CourseSee {
	
	private int t_course_id;//课程id
	private String t_course_name;//课程名称
	private String t_course_introduction;//课程介绍
	private int t_course_anthorid;//课程作者id
	private int t_course_type;//课程类型
	private String t_course_pic;//课程类型
	private String t_course_dynamic;
	
	private int t_course_seesum;//观看数量
	private int t_course_commentsum;//留言数量
	private int t_course_downsum;//下载数量
	private int t_course_collectsum;
	private int t_course_ccollectsum;
	
	
	private int t_coursetype_id;//视频类型id
	private String t_coursetype_name;//视频类型名称
	
	
	//用户信息
	private int t_user_id;//用户id
	private String t_user_username = "";
	private String t_user_imei = "";
	private String t_user_password = "";
	private int t_user_age;
	private int t_user_sex;
	private String t_user_email = "";
	private String t_user_phone = "";
	private String t_user_introduction = "";
	private int t_user_score;
	private String t_user_identitycard = "";//省份证
	private String t_user_truename = "";
	private String t_user_nick = "";
	private String t_user_address = "";
	private String t_user_userhead = "";
	private int t_user_ulevel;
	private int t_user_tlevel;
	private String t_user_logintime;
	
	
	
	
	public String getT_course_dynamic() {
		return t_course_dynamic;
	}
	public void setT_course_dynamic(String tCourseDynamic) {
		t_course_dynamic = tCourseDynamic;
	}
	
	

	public int getT_course_seesum() {
		return t_course_seesum;
	}
	public void setT_course_seesum(int tCoucrseSeesum) {
		t_course_seesum = tCoucrseSeesum;
	}
	public int getT_course_commentsum() {
		return t_course_commentsum;
	}
	public void setT_course_commentsum(int tCourseCommentsum) {
		t_course_commentsum = tCourseCommentsum;
	}
	public int getT_course_downsum() {
		return t_course_downsum;
	}
	public void setT_course_downsum(int tCourseDownsum) {
		t_course_downsum = tCourseDownsum;
	}
	public int getT_course_collectsum() {
		return t_course_collectsum;
	}
	public void setT_course_collectsum(int tCourseCollectsum) {
		t_course_collectsum = tCourseCollectsum;
	}
	public int getT_course_ccollectsum() {
		return t_course_ccollectsum;
	}
	public void setT_course_ccollectsum(int tCourseCcollectsum) {
		t_course_ccollectsum = tCourseCcollectsum;
	}
	public int getT_course_id() {
		return t_course_id;
	}
	public void setT_course_id(int tCourseId) {
		t_course_id = tCourseId;
	}
	public String getT_course_name() {
		return t_course_name;
	}
	public void setT_course_name(String tCourseName) {
		t_course_name = tCourseName;
	}
	public String getT_course_introduction() {
		return t_course_introduction;
	}
	public void setT_course_introduction(String tCourseIntroduction) {
		t_course_introduction = tCourseIntroduction;
	}
	public int getT_course_anthorid() {
		return t_course_anthorid;
	}
	public void setT_course_anthorid(int tCourseAnthorid) {
		t_course_anthorid = tCourseAnthorid;
	}
	public int getT_course_type() {
		return t_course_type;
	}
	public void setT_course_type(int tCourseType) {
		t_course_type = tCourseType;
	}
	public String getT_course_pic() {
		return t_course_pic;
	}
	public void setT_course_pic(String tCoursePic) {
		t_course_pic = tCoursePic;
	}
	public int getT_coursetype_id() {
		return t_coursetype_id;
	}
	public void setT_coursetype_id(int tCoursetypeId) {
		t_coursetype_id = tCoursetypeId;
	}
	public String getT_coursetype_name() {
		return t_coursetype_name;
	}
	public void setT_coursetype_name(String tCoursetypeName) {
		t_coursetype_name = tCoursetypeName;
	}
	public int getT_user_id() {
		return t_user_id;
	}
	public void setT_user_id(int tUserId) {
		t_user_id = tUserId;
	}
	public String getT_user_username() {
		return t_user_username;
	}
	public void setT_user_username(String tUserUsername) {
		t_user_username = tUserUsername;
	}
	public String getT_user_imei() {
		return t_user_imei;
	}
	public void setT_user_imei(String tUserImei) {
		t_user_imei = tUserImei;
	}
	public String getT_user_password() {
		return t_user_password;
	}
	public void setT_user_password(String tUserPassword) {
		t_user_password = tUserPassword;
	}
	public int getT_user_age() {
		return t_user_age;
	}
	public void setT_user_age(int tUserAge) {
		t_user_age = tUserAge;
	}
	public int getT_user_sex() {
		return t_user_sex;
	}
	public void setT_user_sex(int tUserSex) {
		t_user_sex = tUserSex;
	}
	public String getT_user_email() {
		return t_user_email;
	}
	public void setT_user_email(String tUserEmail) {
		t_user_email = tUserEmail;
	}
	public String getT_user_phone() {
		return t_user_phone;
	}
	public void setT_user_phone(String tUserPhone) {
		t_user_phone = tUserPhone;
	}
	public String getT_user_introduction() {
		return t_user_introduction;
	}
	public void setT_user_introduction(String tUserIntroduction) {
		t_user_introduction = tUserIntroduction;
	}
	public int getT_user_score() {
		return t_user_score;
	}
	public void setT_user_score(int tUserScore) {
		t_user_score = tUserScore;
	}
	public String getT_user_identitycard() {
		return t_user_identitycard;
	}
	public void setT_user_identitycard(String tUserIdentitycard) {
		t_user_identitycard = tUserIdentitycard;
	}
	public String getT_user_truename() {
		return t_user_truename;
	}
	public void setT_user_truename(String tUserTruename) {
		t_user_truename = tUserTruename;
	}
	public String getT_user_nick() {
		return t_user_nick;
	}
	public void setT_user_nick(String tUserNick) {
		t_user_nick = tUserNick;
	}
	public String getT_user_address() {
		return t_user_address;
	}
	public void setT_user_address(String tUserAddress) {
		t_user_address = tUserAddress;
	}
	public String getT_user_userhead() {
		return t_user_userhead;
	}
	public void setT_user_userhead(String tUserUserhead) {
		t_user_userhead = tUserUserhead;
	}
	public int getT_user_ulevel() {
		return t_user_ulevel;
	}
	public void setT_user_ulevel(int tUserUlevel) {
		t_user_ulevel = tUserUlevel;
	}
	public int getT_user_tlevel() {
		return t_user_tlevel;
	}
	public void setT_user_tlevel(int tUserTlevel) {
		t_user_tlevel = tUserTlevel;
	}
	public String getT_user_logintime() {
		return t_user_logintime;
	}
	public void setT_user_logintime(String tUserLogintime) {
		t_user_logintime = tUserLogintime;
	}
	
	
	
	private Timestamp t_course_addtime;//课程加入时间
	private Timestamp t_user_addtime;//用户加入时间
	private Timestamp t_coursetype_addtime;//课程类型加入时间
	
	public String getT_course_addtime() {
		return t_course_addtime.toString().replace(".0", "");
	}
	public void setT_course_addtime(Timestamp tCourseAddtime) {
		t_course_addtime = tCourseAddtime;
	}
	public String getT_user_addtime() {
		return t_user_addtime.toString().replace(".0", "");
	}
	public void setT_user_addtime(Timestamp tUserAddtime) {
		t_user_addtime = tUserAddtime;
	}
	public String getT_coursetype_addtime() {
		return t_coursetype_addtime.toString().replace(".0", "");
	}
	public void setT_coursetype_addtime(Timestamp tCoursetypeAddtime) {
		t_coursetype_addtime = tCoursetypeAddtime;
	}

	

	
}
